package com.pasabahceambalaj.session;

import com.pasabahceambalaj.entity.*;
import org.jboss.seam.annotations.Name;
import org.jboss.seam.framework.EntityQuery;
import java.util.Arrays;

@Name("isemirList")
public class IsemirList extends EntityQuery<Isemir> {

	private static final String EJBQL = "select isemir from Isemir isemir";

	private static final String[] RESTRICTIONS = { "lower(isemir.aypaciklama) like lower(concat(#{isemirList.isemir.aypaciklama},'%'))", "lower(isemir.formno) like lower(concat(#{isemirList.isemir.formno},'%'))", "lower(isemir.isemirno) like lower(concat(#{isemirList.isemir.isemirno},'%'))", "lower(isemir.kalipeki) like lower(concat(#{isemirList.isemir.kalipeki},'%'))", "lower(isemir.musterimarkalamasi) like lower(concat(#{isemirList.isemir.musterimarkalamasi},'%'))", "lower(isemir.siparisno) like lower(concat(#{isemirList.isemir.siparisno},'%'))", "lower(isemir.upkaciklama) like lower(concat(#{isemirList.isemir.upkaciklama},'%'))", "lower(isemir.uretimenotlar) like lower(concat(#{isemirList.isemir.uretimenotlar},'%'))", };

	private Isemir isemir = new Isemir();

	public IsemirList() {
		setEjbql(EJBQL);
		setRestrictionExpressionStrings(Arrays.asList(RESTRICTIONS));
		setMaxResults(25);
	}

	public Isemir getIsemir() {
		return isemir;
	}
}
